Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | Nozzle(AS_NZL) |
FuelingPointID (FK)(PK) | A unique identifier for the FuelingPoint at a particular retail store | ID_PNT_FUEL | Identity | integer | Nozzle(AS_NZL) |
NozzleID (FK)(PK) | A unique identifier for the Nozzle | ID_NZL | Identity | integer | Nozzle(AS_NZL) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
ServiceLevelID (FK)(PK) | A unique identifier for the service level | ID_LV_SV | Identity | integer | FuelServiceLevel(CO_LV_SV) |
PriceLevelID (FK)(PK) | A unique identifier for the price level | ID_LV_PRC | Identity | integer | FuelPriceLevel(CO_LV_PRC) |
TimeGroupID (FK)(PK) | A unique identifier for a set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. | ID_GP_TM | Identity | integer | TimeGroup(CO_GP_TM) |
OperatorID (FK)(PK) | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | Operator(PA_OPR) |
PostpayFuelingTransactionCount | The number of FuellingTransactions performed at the LogicalNozzle during the ReportingPeriod | QU_TRN_FUEL_PSPY | QuantityTransactionCount | decimal(7,0) | |
PostpayFuelingTransactionVolume | The total volume of FuellingTransactions performed at the LogicalNozzle during the ReportingPeriod | QV_TRN_FUEL_PSPY | Quantity | decimal(9,2) | |
PostPayFuelingTransactionAmount | The total monetary amount of FuellingTransactions performed at the LogicalNozzle during the ReportingPeriod | MO_TRN_FUEL_PSPY | Money | decimal(16,5) | |
PrepayFuelingTransactionCount | The count of fueling transactions prepaid at the logical nozzle during the reporting period. | QU_TRN_FUEL_PRPY | QuantityTransactionCount | decimal(7,0) | |
PrepayFuelingTransactionVolume | The total volume of fueling transactions prepaid at the logical nozzle during the reporting period. | QV_TRN_FUEL_PRPY | Quantity | decimal(9,2) | |
PrepayFuelingTransactionAmount | The total monetary amount of FuellingTransactions prepaid at the LogicalNozzle during the ReportingPeriod | MO_TRN_FUEL_PRPY | Money | decimal(16,5) | |